USE [AdvEgency]
go
--Off

IF EXISTS(SELECT* FROM SYSOBJECTS WHERE NAME = 'FK_Dictionary_DictionaryType' ) ALTER TABLE [dbo].[Dictionary] DROP CONSTRAINT [FK_Dictionary_DictionaryType] 
GO 

--ON
ALTER TABLE [dbo].[Dictionary]  WITH CHECK ADD  CONSTRAINT [FK_Dictionary_DictionaryType] FOREIGN KEY([DictionaryTypeID])
REFERENCES [dbo].[DictionaryType] ([Id])
GO